Full source code website bán hàng thương mại điện tử gần giống shopee
468.820 lượt xem;
1 <?
2 if (isset($_REQUEST['act']))
3 {
4 ?><br>
5 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
6 <tr>
7 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
8 <td colspan="2" nowrap class="title"> </td>
9 <td align="center" nowrap class="title"><b>ID</b></td>
10 <td align="center" nowrap class="title"><b>Tên </b></td>
11 <td align="center" nowrap class="title"><b>Người đăng</b></td>
12 <td align="center" nowrap class="title"><b>Danh mục hệ thống</b></td>
13 <td align="center" nowrap class="title"><b>Nơi đăng</b></td>
14 <td align="center" nowrap class="title"><b>Ngày đăng</b></td>
15
16 </tr>
17 <?
18 if ($_REQUEST['cat_id']!='') $cat=killInjection($_REQUEST['cat_id']);
19 $catallsub=GetCatJob($cat);
20 $where="1=1";
21 $keywords=killInjection($_REQUEST['keywords']);
22 if ($keywords!='')
23 {
24 $where.=" and (name like '%".$keywords."%' or content like '%".$keywords."%'";
25 $where.=") ";
26 }
27 if ($_REQUEST['cat_id']!='') $where.=" and job_cat in (".$catallsub."0)";
28 if ($_REQUEST['manufacturers_id']!='') $where.=" and providers_id=".$_REQUEST['manufacturers_id'];
29 if ($_REQUEST['pfrom']!='') $where.=" and price>=".$_REQUEST['pfrom'];
30 if ($_REQUEST['pto']!='') $where.=" and price_special<=".$_REQUEST['pto'];
31 if ($_REQUEST['dfrom']!='') $where.=" and products_date_added>=".$_REQUEST['dfrom'];
32 if ($_REQUEST['dto']!='') $where.=" and products_date_added<=".$_REQUEST['dto'];
33
34 $MAXPAGE=20;
35 $p=0;
36 if ($_REQUEST['p']!='') $p=$_REQUEST['p'];
37
38 $result = mysql_query("select count(*) from job where $where ",$con);
39 $total=mysql_fetch_row($result);
40
41 $sql="select * from job where $where limit ".$p*$MAXPAGE.",".$MAXPAGE;
42 $result = mysql_query($sql,$con);
43 $i=0;
44 while (($row=mysql_fetch_assoc($result)))
45 {
46 $catinfo=GetCatJobInfo($row['job_cat']);
47 $cityinfo=GetCityInfo($row['city']);
48 $i++;
49 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
50 ?>
51 <tr>
52 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
53 <input type="checkbox" name="chk[]" value="<? echo $row['id']; ?>"></td>
54 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
55 <a href="./?act=job_m&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>&page=<? echo $page?>">Sửa</a></td>
56 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
57 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=job&action=del&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>">Xoá</a></td>
58 <td bgcolor="<? echo $color; ?>" align="left" align="left" class="smallfont"><? echo $row['id']; ?> </td>
59 <td bgcolor="<? echo $color; ?>" class="smallfont"><a href="../?home=job&act=views&id=<? echo $row['id']; ?>" target="_blank"><? echo $row['name']; ?></a></td>
60 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['user']; ?> </td>
61 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $catinfo['name']; ?> </td>
62 <td bgcolor="<? echo $color; ?>" class="smallfont"><?if($row['city']=='0'){?>TOÀN QUỐC<?}else{?><? echo $cityinfo['name']; ?><?}?> </td>
63 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['date']; ?> </td>
64
65 </tr>
66 <?}
67 settype($total[0],int);
68 ?>
69 </table>
70 <?
71 $s="act=search&act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
72 ?>
73
74 <form id="search1" name="search1" style="word-spacing: 0; margin: 0" method="GET" action="index.php?<? echo $s; ?>">
75 <input type="hidden" name="menu" value="<? echo $_REQUEST['menu']; ?>">
76 <input type="hidden" name="act" value="<? echo $_REQUEST['act']; ?>">
77 <input type="hidden" name="keywords" value="<? echo $_REQUEST['keywords']; ?>">
78 <input type="hidden" name="search_in_description" value="<? echo $_REQUEST['search_in_description']; ?>">
79 <input type="hidden" name="categories_id" value="<? echo $_REQUEST['categories_id']; ?>">
80 <input type="hidden" name="manufacturers_id" value="<? echo $_REQUEST['manufacturers_id']; ?>">
81 <input type="hidden" name="pfrom" value="<? echo $_REQUEST['pfrom']; ?>">
82 <input type="hidden" name="pto" value="<? echo $_REQUEST['pto']; ?>">
83 <input type="hidden" name="dfrom" value="<? echo $_REQUEST['dfrom']; ?>">
84 <input type="hidden" name="dto" value="<? echo $_REQUEST['dto']; ?>">
85 <input type="hidden" id="trang" name="p" value="1">
86 <TABLE cellSpacing=10 cellPadding=0 width="100%" border=0 id="table35" style="line-height: 120%; text-align: justify">
87 <?
88 $pages=count_page($total[0],$MAXPAGE);
89 echo '<tr><td colspan="2" align="center"><hr class="fieldkey" width="100%" SIZE=1></td></tr>';
90 echo '<tr><td class="smallfont" align="left">Trình bày <b>'.($p+1).'</b> đến <b>'.(int)($total[0]/$MAXPAGE+1).'</b> (trong <b>'.$total[0].'</b> sản phẩm)</td>';
91 echo '<td class="smallfont" align="right">Kết quả: ';
92 //$param="act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
93 if ($p>1) echo '<a title="Đầu tiên" href="#" onclick="javascript:changepage(0);return false;">[<]</a> ';
94 if ($p>0) echo '<a title="Về trước" href="#" onclick="javascript:changepage('.($p-1).');return false;">[<<]</a> ';
95 $from=($p-10>0?$p-10:0);
96 $to=($p+10<$pages?$p+10:$pages);
97 for ($i=$from;$i<$to;$i++)
98 {
99 //if ($i!=$p) echo '<a href="./?menu=search&'.$param.'&p='.$i.'">'.($i+1).' </a>';
100 if ($i!=$p) echo '<a href="#" onclick="javascript:changepage('.$i.');return false;">'.($i+1).' </a>';
101 else echo '<b>'.($i+1).'</b> ';
102 }
103 if ($p<$i-1) echo '<a title="Tiếp theo" href="#" onclick="javascript:changepage('.($p+1).');return false;">[>>]</a> ';
104 if ($p<$pages-1) echo '<a title="Cuối cùng" href="#" onclick="javascript:changepage('.($pages-1).');return false;">[>]</a> ';
105 echo '</td></tr></table>';
106 ?>
107 </form>
108
109 <script>
110 function changepage(num)
111 {
112 document.all.trang.value=num;
113 search1.submit();
114 }
115 </script>
116
117 <?
118 }
119 else
120 {
121 ?>
122 <TABLE border="0" cellpadding="10" cellspacing="1" width="100%" id="table1">
123 <TR><TD class="DialogBox">
124 <FORM name="searchform" action="./" method="GET">
125 <table cellSpacing="0" cellPadding="2" width="100%" border="0" id="table2">
126 <tr>
127 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Từ khóa:</span></font></td>
128 <td class="fieldValue" width="55%">
129 <span style="font-size: 8.5pt"><font size="1" face="Tahoma">
130 <input name="keywords" size="255" style="width: 200; height:22"></font></span></td>
131 </tr>
132 <tr>
133 <td width="35%" align="right"> </td>
134 <td class="fieldValue" width="55%">
135 <span style="font-size: 8.5pt"><font face="Tahoma">
136 <input type="checkbox" value="1" name="search_in_description"> Chỉ tìm
137 trong phần mô tả sản phẩm</font></span></td>
138 </tr>
139 <tr>
140 <td width="35%" align="right"> </td>
141 <td class="fieldValue" width="55%">
142 <font face="Verdana" size="1">
143 <span style="font-size: 8.5pt">
144 <font face="Tahoma">
145 <input type=submit value="Tìm kiếm" class=buttonorange onmouseover="this.className='buttonblue'" onmouseout="this.className='buttonorange'"></font></span></font></td>
146 </tr>
147 <tr>
148 <td width="35%" align="right"> </td>
149 <td class="fieldValue" width="55%"> </td>
150 </tr>
151 <tr>
152 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Trong danh mục:</span></font></td>
153 <td class="fieldValue" width="55%">
154 <span style="font-size: 8.5pt"><font face="Tahoma">
155 <select name="categories_id" size="1" style="width: 200">
156 <option selected value="">[Toàn bộ danh mục]</option>
157 <?
158 $cats=GetListCategory(17);
159 foreach ($cats as $cat)
160 {
161 echo '<option value="'.$cat[0].'">'.$cat[1].'</option>';
162 }
163 ?>
164 </select></font></span></td>
165 </tr>
166 <tr>
167 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (>=):</span></font></td>
168 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
169 <font face="Tahoma"><input name="pfrom"></font></span></td>
170 </tr>
171 <tr>
172 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (<=):</span></font></td>
173 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
174 <font face="Tahoma"><input name="pto"></font></span></td>
175 </tr>
176 <tr>
177 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (>=):</span></font></td>
178 <td class="fieldValue" width="55%">
179 <span style="font-size: 8.5pt"><font face="Tahoma">
180 <input name="dfrom"> (tháng/ngày/năm)</font></span></td>
181 </tr>
182 <tr>
183 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (<=):</span></font></td>
184 <td class="fieldValue" width="55%">
185 <span style="font-size: 8.5pt"><font face="Tahoma">
186 <input name="dto"> (tháng/ngày/năm)</font></span></td>
187 </tr>
188 </table>
189
190 <input type="hidden" name="act" value="search">
191
192 <input type="hidden" name="menu" value="search">
193
194 </FORM>
195 </TD></TR>
196 </TABLE>
197 <?
198 }
199 ?>
2 if (isset($_REQUEST['act']))
3 {
4 ?><br>
5 <table border="1" cellpadding="2" style="border-collapse: collapse" bordercolor="#C9C9C9" width="100%" id="AutoNumber1">
6 <tr>
7 <td align=center nowrap class="title"><input type="checkbox" name="chkall" onclick="chkallClick(this);"></td>
8 <td colspan="2" nowrap class="title"> </td>
9 <td align="center" nowrap class="title"><b>ID</b></td>
10 <td align="center" nowrap class="title"><b>Tên </b></td>
11 <td align="center" nowrap class="title"><b>Người đăng</b></td>
12 <td align="center" nowrap class="title"><b>Danh mục hệ thống</b></td>
13 <td align="center" nowrap class="title"><b>Nơi đăng</b></td>
14 <td align="center" nowrap class="title"><b>Ngày đăng</b></td>
15
16 </tr>
17 <?
18 if ($_REQUEST['cat_id']!='') $cat=killInjection($_REQUEST['cat_id']);
19 $catallsub=GetCatJob($cat);
20 $where="1=1";
21 $keywords=killInjection($_REQUEST['keywords']);
22 if ($keywords!='')
23 {
24 $where.=" and (name like '%".$keywords."%' or content like '%".$keywords."%'";
25 $where.=") ";
26 }
27 if ($_REQUEST['cat_id']!='') $where.=" and job_cat in (".$catallsub."0)";
28 if ($_REQUEST['manufacturers_id']!='') $where.=" and providers_id=".$_REQUEST['manufacturers_id'];
29 if ($_REQUEST['pfrom']!='') $where.=" and price>=".$_REQUEST['pfrom'];
30 if ($_REQUEST['pto']!='') $where.=" and price_special<=".$_REQUEST['pto'];
31 if ($_REQUEST['dfrom']!='') $where.=" and products_date_added>=".$_REQUEST['dfrom'];
32 if ($_REQUEST['dto']!='') $where.=" and products_date_added<=".$_REQUEST['dto'];
33
34 $MAXPAGE=20;
35 $p=0;
36 if ($_REQUEST['p']!='') $p=$_REQUEST['p'];
37
38 $result = mysql_query("select count(*) from job where $where ",$con);
39 $total=mysql_fetch_row($result);
40
41 $sql="select * from job where $where limit ".$p*$MAXPAGE.",".$MAXPAGE;
42 $result = mysql_query($sql,$con);
43 $i=0;
44 while (($row=mysql_fetch_assoc($result)))
45 {
46 $catinfo=GetCatJobInfo($row['job_cat']);
47 $cityinfo=GetCityInfo($row['city']);
48 $i++;
49 if ($i%2) $color="#d5d5d5"; else $color="#e5e5e5";
50 ?>
51 <tr>
52 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
53 <input type="checkbox" name="chk[]" value="<? echo $row['id']; ?>"></td>
54 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
55 <a href="./?act=job_m&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>&page=<? echo $page?>">Sửa</a></td>
56 <td align="center" bgcolor="<? echo $color; ?>" class="smallfont">
57 <a onclick="return confirm('Bạn có chắc chắn muốn xoá ?');" href="./?act=job&action=del&cat=<? echo $_REQUEST['cat']; ?>&status=<? echo $_REQUEST['status']; ?>&id=<? echo $row['id']; ?>">Xoá</a></td>
58 <td bgcolor="<? echo $color; ?>" align="left" align="left" class="smallfont"><? echo $row['id']; ?> </td>
59 <td bgcolor="<? echo $color; ?>" class="smallfont"><a href="../?home=job&act=views&id=<? echo $row['id']; ?>" target="_blank"><? echo $row['name']; ?></a></td>
60 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['user']; ?> </td>
61 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $catinfo['name']; ?> </td>
62 <td bgcolor="<? echo $color; ?>" class="smallfont"><?if($row['city']=='0'){?>TOÀN QUỐC<?}else{?><? echo $cityinfo['name']; ?><?}?> </td>
63 <td bgcolor="<? echo $color; ?>" class="smallfont"><? echo $row['date']; ?> </td>
64
65 </tr>
66 <?}
67 settype($total[0],int);
68 ?>
69 </table>
70 <?
71 $s="act=search&act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
72 ?>
73
74 <form id="search1" name="search1" style="word-spacing: 0; margin: 0" method="GET" action="index.php?<? echo $s; ?>">
75 <input type="hidden" name="menu" value="<? echo $_REQUEST['menu']; ?>">
76 <input type="hidden" name="act" value="<? echo $_REQUEST['act']; ?>">
77 <input type="hidden" name="keywords" value="<? echo $_REQUEST['keywords']; ?>">
78 <input type="hidden" name="search_in_description" value="<? echo $_REQUEST['search_in_description']; ?>">
79 <input type="hidden" name="categories_id" value="<? echo $_REQUEST['categories_id']; ?>">
80 <input type="hidden" name="manufacturers_id" value="<? echo $_REQUEST['manufacturers_id']; ?>">
81 <input type="hidden" name="pfrom" value="<? echo $_REQUEST['pfrom']; ?>">
82 <input type="hidden" name="pto" value="<? echo $_REQUEST['pto']; ?>">
83 <input type="hidden" name="dfrom" value="<? echo $_REQUEST['dfrom']; ?>">
84 <input type="hidden" name="dto" value="<? echo $_REQUEST['dto']; ?>">
85 <input type="hidden" id="trang" name="p" value="1">
86 <TABLE cellSpacing=10 cellPadding=0 width="100%" border=0 id="table35" style="line-height: 120%; text-align: justify">
87 <?
88 $pages=count_page($total[0],$MAXPAGE);
89 echo '<tr><td colspan="2" align="center"><hr class="fieldkey" width="100%" SIZE=1></td></tr>';
90 echo '<tr><td class="smallfont" align="left">Trình bày <b>'.($p+1).'</b> đến <b>'.(int)($total[0]/$MAXPAGE+1).'</b> (trong <b>'.$total[0].'</b> sản phẩm)</td>';
91 echo '<td class="smallfont" align="right">Kết quả: ';
92 //$param="act=search&keywords=$keywords&search_in_description=".$_REQUEST['search_in_description']."&categories_id=".$_REQUEST['categories_id']."&manufacturers_id=".$_REQUEST['manufacturers_id']."&pfrom=".$_REQUEST['pfrom']."&pto=".$_REQUEST['pto']."&dfrom=".$_REQUEST['dfrom']."&dto=".$REQUEST['dto'];
93 if ($p>1) echo '<a title="Đầu tiên" href="#" onclick="javascript:changepage(0);return false;">[<]</a> ';
94 if ($p>0) echo '<a title="Về trước" href="#" onclick="javascript:changepage('.($p-1).');return false;">[<<]</a> ';
95 $from=($p-10>0?$p-10:0);
96 $to=($p+10<$pages?$p+10:$pages);
97 for ($i=$from;$i<$to;$i++)
98 {
99 //if ($i!=$p) echo '<a href="./?menu=search&'.$param.'&p='.$i.'">'.($i+1).' </a>';
100 if ($i!=$p) echo '<a href="#" onclick="javascript:changepage('.$i.');return false;">'.($i+1).' </a>';
101 else echo '<b>'.($i+1).'</b> ';
102 }
103 if ($p<$i-1) echo '<a title="Tiếp theo" href="#" onclick="javascript:changepage('.($p+1).');return false;">[>>]</a> ';
104 if ($p<$pages-1) echo '<a title="Cuối cùng" href="#" onclick="javascript:changepage('.($pages-1).');return false;">[>]</a> ';
105 echo '</td></tr></table>';
106 ?>
107 </form>
108
109 <script>
110 function changepage(num)
111 {
112 document.all.trang.value=num;
113 search1.submit();
114 }
115 </script>
116
117 <?
118 }
119 else
120 {
121 ?>
122 <TABLE border="0" cellpadding="10" cellspacing="1" width="100%" id="table1">
123 <TR><TD class="DialogBox">
124 <FORM name="searchform" action="./" method="GET">
125 <table cellSpacing="0" cellPadding="2" width="100%" border="0" id="table2">
126 <tr>
127 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Từ khóa:</span></font></td>
128 <td class="fieldValue" width="55%">
129 <span style="font-size: 8.5pt"><font size="1" face="Tahoma">
130 <input name="keywords" size="255" style="width: 200; height:22"></font></span></td>
131 </tr>
132 <tr>
133 <td width="35%" align="right"> </td>
134 <td class="fieldValue" width="55%">
135 <span style="font-size: 8.5pt"><font face="Tahoma">
136 <input type="checkbox" value="1" name="search_in_description"> Chỉ tìm
137 trong phần mô tả sản phẩm</font></span></td>
138 </tr>
139 <tr>
140 <td width="35%" align="right"> </td>
141 <td class="fieldValue" width="55%">
142 <font face="Verdana" size="1">
143 <span style="font-size: 8.5pt">
144 <font face="Tahoma">
145 <input type=submit value="Tìm kiếm" class=buttonorange onmouseover="this.className='buttonblue'" onmouseout="this.className='buttonorange'"></font></span></font></td>
146 </tr>
147 <tr>
148 <td width="35%" align="right"> </td>
149 <td class="fieldValue" width="55%"> </td>
150 </tr>
151 <tr>
152 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Trong danh mục:</span></font></td>
153 <td class="fieldValue" width="55%">
154 <span style="font-size: 8.5pt"><font face="Tahoma">
155 <select name="categories_id" size="1" style="width: 200">
156 <option selected value="">[Toàn bộ danh mục]</option>
157 <?
158 $cats=GetListCategory(17);
159 foreach ($cats as $cat)
160 {
161 echo '<option value="'.$cat[0].'">'.$cat[1].'</option>';
162 }
163 ?>
164 </select></font></span></td>
165 </tr>
166 <tr>
167 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (>=):</span></font></td>
168 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
169 <font face="Tahoma"><input name="pfrom"></font></span></td>
170 </tr>
171 <tr>
172 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Giá (<=):</span></font></td>
173 <td class="fieldValue" width="55%"><span style="font-size: 8.5pt">
174 <font face="Tahoma"><input name="pto"></font></span></td>
175 </tr>
176 <tr>
177 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (>=):</span></font></td>
178 <td class="fieldValue" width="55%">
179 <span style="font-size: 8.5pt"><font face="Tahoma">
180 <input name="dfrom"> (tháng/ngày/năm)</font></span></td>
181 </tr>
182 <tr>
183 <td width="35%" align="right"><font face="Tahoma"><span style="font-size: 8.5pt">Ngày (<=):</span></font></td>
184 <td class="fieldValue" width="55%">
185 <span style="font-size: 8.5pt"><font face="Tahoma">
186 <input name="dto"> (tháng/ngày/năm)</font></span></td>
187 </tr>
188 </table>
189
190 <input type="hidden" name="act" value="search">
191
192 <input type="hidden" name="menu" value="search">
193
194 </FORM>
195 </TD></TR>
196 </TABLE>
197 <?
198 }
199 ?>
